Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 8 Forum

Notes/Domino 8 Forum
Previous Next
Subject: Formatting Excel Graphs from Lotus Script
Feedback Type: Question
Product Area: Designer Client
Technical Area: Application development
Platform: Windows Vista client
Release: 8.0.2
Reproducible: Always

Hi, I am coding a script to export a lot of data from a Notes database to an Excel sheet including graphs. At the end I would like to format the colors used in the graph. I am currently using the following line for this:

xlApp.ActiveWorkbook.ActiveChart.Legend.LegendEntries(1).LegendKey.Fill.ForeColor.SchemeColor = 3

which is working quite well but would anyone know what to use to get access to the full RGB color palette?

(Like the difference between xlsheet.Cells(1,1).font.color and xlsheet.Cells(1,1).font.colorindex for the cell font color).


Feedback number WEBB9DFLEQ created by ~Delores Opboosikonylen on 11/14/2013


Formatting Excel Graphs from Lotus ... (~Delores Opboos... 14.Nov.13)
. . Quick search of google for Excel VB... (~Fritz Ekfoober... 19.Nov.13)
. . Might be best to try an MS Excel VB... (~August Cispone... 18.Nov.13)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS